package com.manage.mapper;

import com.manage.pojo.UserDetails;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;
import tk.mybatis.mapper.common.Mapper;

@Repository
public interface UserDetailsMapper extends Mapper<UserDetails> {

    @Select("select  d.* from  tb_user_details d left join tb_user_base_details bd on bd.details_id=d.id where bd.base_job_id=#{jobNumber}")
    UserDetails queryByJobNumber(@Param("jobNumber") Long jobNumber);
}
